﻿CREATE TABLE [dbo].[dim_Time] (
    [ID]                 INT          NULL,
    [TimeKey]            VARCHAR (15) NOT NULL,
    [Tag]                VARCHAR (15) NULL,
    [Wochentag]          VARCHAR (15) NULL,
    [Monat]              VARCHAR (2)  NULL,
    [Jahr]               INT          NULL,
    [Monat des Jahres]   VARCHAR (15) NULL,
    [Quartal]            VARCHAR (2)  NULL,
    [Quartal des Jahres] VARCHAR (15) NULL,
    CONSTRAINT [PK_tblTime] PRIMARY KEY CLUSTERED ([TimeKey] ASC)
);

